#coding=utf-8
from common.sqlOperate import *
if __name__ == '__main__':
    # host = '192.168.3.108'
    host = 'localhost'
    port = 3306
    user = 'root'
    password = 'root1234'
    # db='gwza0204'
    db = 'gwza_refactory_local'
    #name = "警告型 — 禁止入内"
    #读取需要被修改的信息id
    df = pd.read_excel('./config/data.xls', sheet_name='Sheet1', header=0)
    values = df.values
    ob = sqlOperate(host, port, user, password, db)
    ob.sqlConnect()

    # 修改安全帽类型
    ob.changeDeviceType(values)

    ob.closeConnection()